package com.example.back.mapper.otd;

import com.example.back.entity.otd.Videos;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.ArrayList;

@Mapper
public interface VideoMapper {
    @Select("SELECT v.face, v.url, v.length, v.title, v.userId, u.tx, u.yhm FROM video v, user u WHERE v.userId = u.id")
    ArrayList<Videos> getVideos();
}
